import pandas as pd

pd.set_option('display.max_columns', None)
pd.set_option('display.width', None)
pd.set_option('display.max_colwidth', None)

if __name__ == '__main__':
    users = pd.read_csv('20251119users.csv')
    print(users.head())

    assistant_stat = pd.read_csv('2.txt', sep='\t')
    print(assistant_stat.head())

    merge = pd.merge(assistant_stat, users, left_on="账号", right_on='user_account', how="left")
    print(merge)